<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>订单查询</title>
    <!-- Bootstrap CSS-->
    <link rel="stylesheet" href="../../static/css/lib/bootstrap3.4.1.min.css" th:href="@{/css/lib/bootstrap3.4.1.min.css}">
    <!-- Bootstrap-table CSS-->
    <link rel="stylesheet" href="../../static/css/lib/bootstrap-table.min.css" th:href="@{/css/lib/bootstrap-table.min.css}">
    <!-- jquery-ui CSS-->
    <link rel="stylesheet" href="../../static/css/lib/jquery-ui.min.css" th:href="@{/css/lib/jquery-ui.min.css}">
    <!-- select2 CSS-->
    <link rel="stylesheet" href="../../static/css/lib/select2.min.css" th:href="@{/css/lib/select2.min.css}">
    <link rel="stylesheet" href="../../static/css/lib/select2-bootstrap.min.css" th:href="@{/css/lib/select2-bootstrap.min.css}">
    <link href="../../static/css/file.css" rel="stylesheet" th:href="@{/css/file.css}">
    <link href="../../static/css/table.css" rel="stylesheet" th:href="@{/css/table.css}">
</head>

<body onload="init();">
<div class="panel-body" style="padding-bottom:0;">
    <div class="panel panel-default">
        <div class="panel-heading">查询条件</div>
        <div class="panel-body">
            <div class="form-group" style="margin-top:15px">
                <div class="row row-gap">
                    <label class="control-label col-sm-2 label-font" for="txt_search_order_number" title="订购单号">订购单号</label>
                    <div class="col-sm-4">
                        <input type="text" class="form-control" id="txt_search_order_number">
                    </div>

                    <label class="control-label col-sm-2 label-font" for="txt_search_code" title="客户代号">客户代号</label>
                    <div class="col-sm-4">
                        <input type="text" class="form-control" id="txt_search_code">
                    </div>
                </div>

                <div class="row row-gap">
                    <label class="control-label col-sm-2 label-font" for="txt_search_item_name" title="品名">品名</label>
                    <div class="col-sm-4">
                        <input type="text" class="form-control" id="txt_search_item_name">
                    </div>

                    <label class="control-label col-sm-2 label-font" for="txt_search_spec" title="规格">规格</label>
                    <div class="col-sm-4">
                        <input type="text" class="form-control" id="txt_search_spec">
                    </div>
                </div>

                <div class="row row-gap">
                    <label class="control-label col-sm-2 label-font" for="txt_search_product_number" title="客户料号">客户料号</label>
                    <div class="col-sm-4">
                        <input type="text" class="form-control" id="txt_search_product_number">
                    </div>

                    <label class="control-label col-sm-2 label-font" for="txt_search_is_genera_manufacture" title="是否生成制造流程单">是否生成制造流程单</label>
                    <div class="col-sm-4">
                        <select class="form-control" id="txt_search_is_genera_manufacture">
                            <option value="--请选择--">--请选择--</option>
                            <option value="是">是</option>
                            <option value="否">否</option>
                        </select>
                    </div>
                </div>

                <div class="row row-gap">
                    <label class="control-label col-sm-2 label-font" for="txt_search_start_time" title="开始时间">采购日期</label>
                    <div class="col-sm-4">
                        <input type="datetime-local" class="form-control" id="txt_search_start_time">
                    </div>

                    <label class="control-label col-sm-2 label-font" for="txt_search_end_time" title="结束时间">——</label>
                    <div class="col-sm-4">
                        <input type="datetime-local" class="form-control" id="txt_search_end_time">
                    </div>
                </div>

                <div class="row row-gap">
                    <label class="control-label col-sm-2 label-font" for="txt_search_start_delivery_time" title="开始时间">交货日期</label>
                    <div class="col-sm-4">
                        <input type="datetime-local" class="form-control" id="txt_search_start_delivery_time">
                    </div>

                    <label class="control-label col-sm-2 label-font" for="txt_search_end_delivery_time" title="结束时间">——</label>
                    <div class="col-sm-4">
                        <input type="datetime-local" class="form-control" id="txt_search_end_delivery_time">
                    </div>
                </div>

                <div class="row row-gap">
                    <div class="col-sm-offset-4" style="text-align:left;">
                        <button type="button" style="margin-left:50px" id="btn_filter" class="btn btn-primary" onclick="filter();">过滤</button>
                        <button type="button" style="margin-left:50px" id="btn_reset_filter" class="btn btn-primary" onclick="init();">重置过滤</button>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div id="toolbar" class="btn-group">
        <button id="btn_export" type="button" class="btn btn-default" onclick="exportExcel();">
            <span class="glyphicon glyphicon-export" aria-hidden="true"></span>批量导出
        </button>
    </div>
    <table id="table"></table>

    <!-- 模态框（Modal） -->
    <div class="modal fade" id="viewModal" tabindex="-1" role="dialog" aria-labelledby="viewModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                        &times;
                    </button>
                    <h4 class="modal-title" id="viewModalLabel">
                        查看客户订单信息
                    </h4>
                </div>
                <div class="modal-body">
                    <table class="table">
                        <caption>客户订单信息</caption>
                        <tbody>
                        <tr>
                            <td>订购单号</td>
                            <td id="td_order_number">xxx</td>
                        </tr>
                        <tr>
                            <td>客户</td>
                            <td id="td_name">xxx</td>
                        </tr>
                        <tr>
                            <td>原始成品</td>
                            <td id="td_item_name">xxx</td>
                        </tr>
                        <tr>
                            <td>订单数量</td>
                            <td id="td_order_amount">xxx</td>
                        </tr>
                        <tr>
                            <td>投产数量</td>
                            <td id="td_product_amount">xxx</td>
                        </tr>
                        <tr>
                            <td>每单数量</td>
                            <td id="td_every_product_amount">xxx</td>
                        </tr>
                        <tr>
                            <td>每单投产数量</td>
                            <td id="td_every_order_amount">xxx</td>
                        </tr>
                        <tr>
                            <td>采购日期</td>
                            <td id="td_order_date">xxx</td>
                        </tr>
                        <tr>
                            <td>交货日期</td>
                            <td id="td_delivery_date">xxx</td>
                        </tr>
                        <tr>
                            <td>计划到账日期</td>
                            <td id="td_plan_arrival_date">xxx</td>
                        </tr>
                        <tr>
                            <td>实际到账日期</td>
                            <td id="td_actual_arrival_date">xxx</td>
                        </tr>
                        <tr>
                            <td>是否到账</td>
                            <td id="td_is_arrival">xxx</td>
                        </tr>
                        <tr>
                            <td>备注</td>
                            <td id="td_remark">xxx</td>
                        </tr>
                        </tbody>
                    </table>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">关闭
                    </button>
                </div>
            </div><!-- /.modal-content -->
        </div><!-- /.modal -->
    </div>
</div>

<!-- JavaScript files-->
<!-- jquery.js -->
<script src="../../static/js/lib/jquery.min.js" th:src="@{/js/lib/jquery.min.js}"></script>
<!-- Bootstrap.js -->
<script src="../../static/js/lib/bootstrap3.4.1.min.js" th:src="@{/js/lib/bootstrap3.4.1.min.js}"></script>
<!-- Bootstrap-table.js -->
<script src="../../static/js/lib/bootstrap-table.min.js" th:src="@{/js/lib/bootstrap-table.min.js}"></script>
<script src="../../static/js/lib/bootstrap-table-zh-CN.min.js" th:src="@{/js/lib/bootstrap-table-zh-CN.min.js}"></script>
<!-- sweetalert2.js -->
<script src="../../static/js/lib/sweetalert.min.js" th:src="@{/js/lib/sweetalert.min.js}"></script>
<script src="../../static/js/lib/es6-promise.auto.min.js" th:src="@{/js/lib/es6-promise.auto.min.js}"></script>
<!-- jquery-ui.js -->
<script src="../../static/js/lib/jquery-ui.min.js" th:src="@{/js/lib/jquery-ui.min.js}"></script>
<!-- select2.js -->
<script src="../../static/js/lib/select2.min.js" th:src="@{/js/lib/select2.min.js}"></script>
<script src="../../static/js/lib/Select2-zh-CN.js" th:src="@{/js/lib/Select2-zh-CN.js}"></script>
<script src="../../static/js/common.js" th:src="@{/js/common.js}"></script>
<script src="../../static/js/dragModel.js" th:src="@{/js/dragModel.js}"></script>
<script>
    /** 初始化 */
    let $table = $('#table');

    // 服务器分页获取数据
    function getServerPaging(node, url, queryParams) {
        initTable(node, url, [10, 20, 30, 40, 50, 60, "All"], queryParams, [{
            checkbox: true
        }, {
            field: 'orderNumber',
            title: '订单号',
            width: '170px',
            formatter: stringFormatter
        }, {
            field: 'code',
            title: '客户代码',
            width: '90px',
            formatter: stringFormatter
        }, {
            field: 'name',
            title: '客户名称',
            width: '210px',
            formatter: stringFormatter
        }, {
            field: 'itemName',
            title: '品名／磁棒／尺寸(材质)',
            width: '170px',
            formatter: stringFormatter
        }, {
            field: 'spec',
            title: '规格/初R值/电阻线(线径)',
            width: '170px',
            formatter: stringFormatter
        }, {
            field: 'unit',
            title: '单位',
            width: '80px',
            formatter: stringFormatter
        }, {
            field: 'productNumber',
            title: '客户料号',
            width: '170px',
            formatter: stringFormatter
        }, {
            field: 'orderAmount',
            title: '订单数量',
            width: '100px',
            formatter: stringFormatter
        }, {
            field: 'productAmount',
            title: '投产数量',
            width: '100px',
            formatter: stringFormatter
        }, {
            field: 'everyOrderAmount',
            title: '每单投产数量',
            width: '100px',
            formatter: stringFormatter
        }, {
            field: 'everyProductAmount',
            title: '每单数量',
            width: '100px',
            formatter: stringFormatter
        }, {
            field: 'orderDate',
            title: '采购日期',
            width: '170px',
            formatter: dateFormatter
        }, {
            field: 'deliveryDate',
            title: '交货日期',
            width: '170px',
            formatter: dateFormatter
        }, {
            field: 'planArrivalDate',
            title: '计划到账日期',
            width: '170px',
            formatter: dateFormatter
        }, {
            field: 'actualArrivalDate',
            title: '实际到账日期',
            width: '170px',
            formatter: dateFormatter
        }, {
            field: 'isArrival',
            title: '是否到账',
            width: '90px',
            formatter: stringFormatter
        }, {
            field: 'checkFlag',
            title: '业务人员审状态',
            width: '120px',
            formatter: stringFormatter
        }, {
            field: 'finalCheckFlag',
            title: '生产管理人员审核状态',
            width: '160px',
            formatter: stringFormatter
        }, {
            field: 'isGeneraManufacture',
            title: '是否生成制造流程单',
            width: '160px',
            formatter: stringFormatter
        }, {
            field: 'createTime',
            title: '录入日期',
            width: '170px',
            formatter: dateFormatter
        }, {
            field: 'operation',
            title: '操作',
            width: '80px',
            formatter: operateFormatter // 自定义方法，添加操作按钮
        }]);
    }

    function operateFormatter(value, row, index) {  // 赋予的参数
        return [ '<button class="btn btn-success view" data-toggle="modal" data-target="#viewModal" onclick="view('+ index +');">查看</button>' ].join('');
    }

    // 修改提示框样式
    changeToolTip();

    // 模态框初始化
    dragTheModalDialog();

    // 初始化表格数据
    function init() {
        getServerPaging($table, "/order-query/getOrderQuery", params => {
            return { limit: params.limit, offset: params.offset, sort: "create_time", order: "DESC" };
        });
    }
</script>
<script>
    /** 功能 */
    // 过滤
    function filter() {
        let time = [$("#txt_search_start_time"), $("#txt_search_end_time")];
        let deliveryDateTime = [$("#txt_search_start_delivery_time"), $("#txt_search_end_delivery_time")];
        if ("" !== time[0][0].validationMessage || "" !== time[1][0].validationMessage || "" !== deliveryDateTime[0][0].validationMessage || "" !== deliveryDateTime[1][0].validationMessage) {
            swal("操作提示", "请填写完整的时间", "info");
            return;
        }

        let data = { itemName: $("#txt_search_item_name").val(), orderNumber: $("#txt_search_order_number").val(), code: $("#txt_search_code").val(),
            productNumber: $("#txt_search_product_number").val(), isGeneraManufacture: $("#txt_search_is_genera_manufacture").val(), spec: $("#txt_search_spec").val(),
            startTime: time[0].val(), endTime: time[1].val(), startDeliveryDateTime: deliveryDateTime[0].val(), endDeliveryDateTime: deliveryDateTime[1].val()};

        if ("" === data["orderNumber"] && "" === data["code"] && "" === data["productNumber"]&& "" === data["spec"] && "--请选择--" === data["isGeneraManufacture"]
            && "" === data["itemName"] && "" === data["startDeliveryDateTime"] && "" === data["endDeliveryDateTime"]&& "" === data["startTime"] && "" === data["endTime"]) {
            swal("操作提示", "请填写过滤参数", "info");
            return;
        }

        getServerPaging($table, "/order-query/getOrderQueryByConditions", params => {
            let result = { limit: params.limit, offset: params.offset, sort: "create_time", order: "DESC", orderNumber: data["orderNumber"], itemName: data["itemName"],
                code: data["code"], productNumber: data["productNumber"], isGeneraManufacture: data["isGeneraManufacture"], spec: data["spec"],
                startDeliveryDateTime: data["startDeliveryDateTime"], endDeliveryDateTime: data["endDeliveryDateTime"], startTime: data["startTime"], endTime: data["endTime"] };

            removeEmptyField(result);
            if ("--请选择--" === result["isGeneraManufacture"]) {
                delete result["isGeneraManufacture"];
            }

            return result;
        });
    }

    // 导出excel
    function exportExcel() {
        let selections = $table.bootstrapTable('getSelections');
        if (selections.length === 0) {
            swal("操作提示", "请选择记录", "info");
        } else {
            parameterPostRequest("/order-query/exportExcel", selections, () => loadFile("订单查询信息.xlsx"));
        }
    }

    // 查看
    function view(index) {
        let rows = $table.bootstrapTable('getData');
        $("#td_order_number").text(rows[index].orderNumber);
        $("#td_name").text(rows[index].name);
        $("#td_item_name").text(rows[index].itemName);
        $("#td_order_amount").text(rows[index].orderAmount);
        $("#td_product_amount").text(rows[index].productAmount);
        $("#td_every_product_amount").text(rows[index].everyProductAmount);
        $("#td_every_order_amount").text(rows[index].everyOrderAmount);
        if (rows[index].orderDate != null){
            $("#td_order_date").text(formatDateTime(rows[index].orderDate));
        }else{
            $("#td_order_date").text("");
        }
        if (rows[index].deliveryDate != null){
            $("#td_delivery_date").text(formatDateTime(rows[index].deliveryDate));
        }else{
            $("#td_delivery_date").text("");
        }
        if (rows[index].planArrivalDate != null){
            $("#td_plan_arrival_date").text(formatDateTime(rows[index].planArrivalDate));
        }else{
            $("#td_plan_arrival_date").text("");
        }
        if (rows[index].actualArrivalDate != null){
            $("#td_actual_arrival_date").text(formatDateTime(rows[index].actualArrivalDate));
        }else{
            $("#td_actual_arrival_date").text("");
        }
        $("#td_is_arrival").text(rows[index].isArrival);
        $("#td_remark").text(rows[index].remark);
    }

</script>

</body>

</html>